SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}Cancelada{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}Cancelada{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}Spain{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}Spain{8628da899fa4ffb89fd35c27da67b64dc76b7a194d0dcaab0822b69f7208803a}' OR prCountry = 'Spain')